SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531716 LIMIT 1 [ RunTime:0.000511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531716 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440789,73353,819748,687771,396769,862219,35160,27823,441568,702890,919872,262906,351157,582246,722551,44570,759597,681152,850814,888051,54147,183668,169223,321450,810152,828684,60754,313020,780001,952933,636294,543267,16723,606108,1022268,390740,820604,865450,244497,662197,749978,167646,450657,280710,95034,251968,880252,119289,704427,585461,595243,397785,717653,253439,465870,934397,361894,752859,793630,570132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]