SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509341 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509341 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803877,355274,97516,152623,87768,655115,71674,1025915,520188,586040,692460,119586,715429,78233,1009128,979196,573785,441811,488639,69415,827479,38259,91869,935313,1048518,285040,283192,433291,599033,480446,865435,621778,120556,492278,154873,910292,399600,20502,775048,770994,257486,940039,822995,948300,293900,761303,723235,117483,992418,406748,77053,87130,901949,44866,478718,882822,1038724,73034,863866,220584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]