SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021580 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021580 [ RunTime:0.003611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275001,947576,24244,407535,906578,162800,203160,151224,331584,13562,806129,685816,745104,254136,594582,776132,703458,852797,235977,135627,900917,68835,972115,203999,253845,130279,226960,1019859,133860,981705,349087,233912,907932,657563,591067,781143,129396,297172,929418,435969,236396,627371,743636,21771,361287,369742,867551,846392,134774,277146,920951,337543,870541,996893,464590,417480,304430,576587,156136,528288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004025s ]