SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 819098 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 819098 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818830,760554,65128,987916,917508,726833,279898,397328,125611,515721,1036040,61433,72366,204480,162390,792602,689676,54310,41266,499788,194678,657906,241941,445055,196730,505975,664545,382946,71587,661078,894366,357739,503363,352032,136188,365845,78991,234807,214288,282172,115027,722925,211620,2974,358428,913607,524452,808700,947881,928154,849607,196504,751931,445838,618764,205327,540390,245356,556707,261396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 819098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 819098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]