SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204179 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204179 [ RunTime:0.003296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926783,342523,820590,502942,102436,28199,333878,461654,530493,809432,207663,540521,512051,100154,294474,294973,211745,313932,319212,909584,742109,636697,142670,265942,973777,282019,334383,511011,746877,920153,341124,482024,270196,764171,224833,403209,211913,620983,114519,588609,42703,146209,973175,675948,707837,33548,961399,488135,288227,1016411,752061,802848,518526,155667,529619,534409,596485,515239,988023,586635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]