SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044074 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044074 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746092,208739,870097,722423,834517,807532,764216,53124,159742,863833,374982,427714,75618,134027,762580,33509,1034182,430274,57915,613869,588120,837195,170536,216916,211263,428458,151189,1027430,231262,357935,478502,383390,634155,498335,409208,530993,299684,799287,10140,447131,714678,254414,24122,800293,89899,150053,265565,568218,223449,434924,835801,414821,946469,559188,745646,480973,601871,415800,221178,644883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]