SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135114 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135114 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008200,388215,132018,519290,765470,871478,773167,878852,540109,583386,408711,829501,1047626,365678,993838,228627,734937,216426,69614,58066,297890,224135,770413,444066,615849,971976,173921,4903,479400,59780,344189,281601,316415,501867,402222,765075,401160,369945,1006342,608698,701893,759034,957307,285811,87552,835187,589629,976654,230686,297379,61246,56177,779009,577277,56831,759858,574331,366154,305726,245256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]