SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442921 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442921 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350939,792027,296261,716224,905279,510428,127707,460424,904994,777050,954979,915668,684285,933492,662789,393689,727063,812635,1003970,192761,886428,368417,107555,203422,618457,96812,520450,976894,294249,1039441,141109,151756,563235,969052,665867,222722,806935,530389,462347,1042359,796838,664339,994635,538049,53803,624233,783806,137416,781796,381640,3276,461049,593814,497864,557288,709729,237104,825358,238599,120146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]