SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029712 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029712 [ RunTime:0.005868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587525,326623,792874,482856,751958,521325,98800,972512,500301,928851,992691,782667,801538,109578,427906,818906,388434,311331,251014,350768,1023848,764285,1046048,347512,779983,548774,933478,580193,316504,146761,811752,118610,474983,565986,479196,234487,765195,299551,248036,377236,472012,444724,181581,717343,500694,805072,975544,666637,139468,752448,131511,474919,29424,741445,318553,158901,1045910,472780,984392,296213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]