SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327303 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327303 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580444,336538,141354,110176,520121,855113,385076,540078,413405,875686,98814,127303,259800,946646,140423,398240,415283,607650,479353,548312,386652,931860,490245,14481,250003,234282,541629,332214,216508,192457,1031534,571843,366728,211878,159385,341742,559544,25915,1015476,319211,298560,565626,605702,787520,347783,945111,1008058,163256,882930,634765,363901,386650,539365,627094,899496,184514,963219,250994,359799,956299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]