SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434813 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434813 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455942,451716,91529,600215,281384,944617,265980,665535,307011,539143,840719,352620,684771,659191,893041,1038376,710933,886956,253669,413065,990879,993734,813929,637864,102682,544868,391696,414257,132820,682649,95870,948713,378140,562248,14814,266749,1030380,433184,359761,805938,321847,191458,885501,528519,839866,567435,209399,505625,860517,962748,1034209,80987,786883,1001545,589891,548570,434274,1041169,643330,107977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004140s ]