SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001920s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513158 LIMIT 1 [ RunTime:0.000606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513158 [ RunTime:0.002480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257491,537724,11836,666641,4913,421027,696711,359337,385003,248093,339011,531395,821257,865582,209788,141788,915293,69386,651272,151245,304457,851569,578248,11451,873529,248857,398970,44369,240761,956975,63618,994872,890421,684674,525827,656844,944187,210425,403467,992707,469184,468427,773399,512886,581364,169472,593841,576836,7287,73323,912980,84637,531405,56732,442111,121325,482927,53355,178223,611452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]