SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 956148 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 956148 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506730,567619,900406,374000,437538,489767,701356,609031,561585,593009,44736,324350,46694,664740,791782,103947,345567,602657,248673,713565,96990,891206,695828,649643,711456,1012187,373202,69829,500087,119481,812274,507253,676382,192210,95998,952834,740117,455539,591300,59275,924316,298339,804903,541940,719550,724794,26229,718291,716975,138731,140264,348326,308075,2507,541916,799035,253391,904319,15305,1008398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 956148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 956148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]