SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527106 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527106 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004312,660563,754506,427158,610654,964583,871815,502614,477668,193611,244803,972748,165299,732209,113665,485733,446111,504544,15119,848631,1027420,152028,1018662,824161,719375,98562,952967,998609,671312,293648,71600,1028137,773423,326943,778724,121240,673513,419474,1005643,117121,304999,917683,638547,702380,485949,491095,410101,394553,801875,802190,767446,386825,671997,825392,173511,176021,596603,519989,285620,834513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]