SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106414 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106414 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342475,326654,650172,172111,224986,73602,275999,686762,581346,122212,878980,237179,856918,469,983367,485449,830075,773463,424842,728337,920118,844000,228218,593457,1007874,163234,536354,976224,28167,73170,987105,228884,865503,137771,983953,678106,983893,873698,418495,199489,450326,621449,564238,371670,922782,750212,91226,24845,198194,257803,698176,1015750,967798,501736,129976,690889,431103,498687,340874,199950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]