SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281516 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281516 [ RunTime:0.002332s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579375,912000,979636,61332,488934,195258,543227,36221,725891,60983,80595,389337,5546,450287,485037,1025522,353517,990442,710614,744658,924247,187609,1004239,390039,679971,323210,797227,118186,930200,562095,163929,602777,223763,202388,25872,640927,491858,410208,905436,2081,775701,546870,356403,851609,583467,1231,1011804,254253,727781,149880,734869,765976,140510,801345,784394,967976,317445,24266,238222,535763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]