SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015498 LIMIT 1 [ RunTime:0.002220s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015498 [ RunTime:0.005062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458035,583412,25588,327037,636038,921522,949366,91767,219425,891874,308096,895472,39656,1045163,1007974,234731,963799,1967,201196,853118,947134,243985,54840,490542,823529,179851,1015244,277223,121767,432036,157097,23914,525859,446763,765363,389612,74996,751762,520371,502323,265791,280397,21708,65056,80150,711904,514713,752664,346680,45332,285443,291146,615372,948746,997323,633830,644996,448878,62306,224888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000749s ]