SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180060 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180060 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187056,502179,661103,569572,678444,843860,648147,691196,863405,271303,73970,501800,932199,713838,171160,11835,180113,787886,98552,775504,971997,896376,517446,837267,52743,344513,287076,263499,457186,656220,218509,500746,989952,428402,614706,371525,385103,750669,108422,833890,273959,76289,332999,687782,824958,940353,912934,450881,159309,634785,768916,391086,132613,140064,871654,1014934,918840,55976,607112,688262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001333s ]