SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474813 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474813 [ RunTime:0.003221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572219,514930,860716,11219,912810,205547,905118,202167,118852,858126,97035,995542,253106,930654,597236,512814,129235,533821,748992,453134,177827,726280,458508,670842,424818,136379,104984,216812,697545,211768,861279,822682,487122,85492,402991,523864,1036895,228890,1005451,1020899,719286,436571,141513,435013,748127,845872,494522,756581,894071,524924,382695,674382,284039,809199,127246,355520,339618,586252,807765,897460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]