SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 134398 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 134398 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522146,917567,608119,171299,276194,589559,593595,74563,976438,339395,734798,435835,290657,5287,571776,355699,443434,122607,959800,372535,337618,803131,769616,976000,980204,624531,692511,130138,63259,207488,257639,54991,1040227,866605,569434,759558,423892,1003686,1046126,991137,1019218,817552,97582,737844,160609,445170,557775,480622,474554,328665,311627,128268,80231,474886,284663,1000410,360630,293710,739975,702973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 134398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 134398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]