SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468411 LIMIT 1 [ RunTime:0.001631s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468411 [ RunTime:0.002874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309538,241394,1035419,457636,111300,685462,975491,945255,530516,1009739,552147,799213,343791,906790,210476,595002,264767,209405,262399,215009,572794,807939,51664,637692,362172,695365,682477,551125,96261,205139,609161,130855,873602,224136,504012,812584,628566,674927,395133,315507,726676,331259,420154,503330,129071,876313,776629,236904,361400,1044462,507989,878527,903191,94801,933545,224255,784563,295933,754225,882283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002924s ]