SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001677s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540798 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540798 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807332,271478,296624,898129,89217,785440,628951,945076,488608,280043,896976,954017,211151,288598,698997,608852,435136,802784,218158,100767,1020591,226324,539533,824076,438949,31923,69768,399208,271892,887893,50584,536675,472128,944794,994139,214219,457399,542938,119306,181514,423442,378315,403196,975957,111383,121820,421434,509265,794826,501,406308,69205,469154,175529,1003976,882466,853231,976021,758117,282029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]