SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 223190 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 223190 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511528,302742,421493,20127,691233,709027,463059,712722,199686,1041175,354535,168205,161411,305586,909743,407914,916276,957113,685177,786939,310136,923835,695639,181956,439395,342788,737419,528774,4089,1000310,50338,705009,315572,949798,133589,166361,488361,818585,319335,203044,78159,41786,551887,133086,834200,170743,518261,346178,765187,327504,948592,201766,492244,860777,372897,777555,617344,781739,557742,762502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 223190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 223190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]