SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249480 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249480 [ RunTime:0.008366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732293,889341,23185,293899,231966,246779,864740,851557,4850,565765,116480,576577,185782,811181,295802,339859,478748,552305,876704,201068,342773,877031,524705,757781,328960,401421,279335,809286,913644,806206,378656,850152,1005043,354299,916692,26653,53030,1039549,892543,346061,624168,1046348,971591,359269,329877,922061,343816,584571,775574,453292,817787,827800,550948,665798,856164,829744,561898,888963,983805,920086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]