SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100208 LIMIT 1 [ RunTime:0.001229s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100208 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017043,976398,349530,829559,902367,727212,891777,975409,1036064,863439,411771,961253,465029,802133,546002,169247,1019008,64303,973814,1028762,128428,53918,53738,350775,279703,414485,970889,186802,591676,288867,685436,435527,200816,540816,821706,558959,363402,942255,770957,1029825,942005,398781,453937,467918,415518,515422,129007,748831,281324,394772,918692,230574,517525,602541,173782,584393,289330,877526,23725,272033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001214s ]