SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508294 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508294 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731493,102962,255701,856292,143541,923053,12510,626904,213249,296827,157615,796743,454799,825445,998670,689121,164723,108942,198764,544192,908663,572351,827808,574442,890735,171877,58486,1033575,531868,818630,602411,642071,397594,524927,140358,908078,651051,110359,405808,769118,549688,289390,28394,814832,813481,547791,30289,484803,913440,1023570,487369,813631,2002,588961,927366,684120,51002,418913,423368,1032805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]