SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523891 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523891 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898959,340148,71718,1003374,528622,644600,663,859208,142387,1029625,567103,941578,881237,1014599,7757,317015,977398,35703,191782,659772,931909,529365,645567,294449,130200,395081,68905,751231,785912,656709,729819,642266,63875,360164,235435,111778,645051,869675,76763,621695,439251,264979,88713,375703,561951,665467,710257,552311,470492,957714,789959,522026,161066,609082,255320,267078,609736,460527,433336,346221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]