SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544341 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544341 [ RunTime:0.003217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794520,525703,814940,226244,293718,146820,210102,658164,414323,580573,762836,579761,870273,796353,638743,258285,826987,286583,453321,718742,868973,364572,635309,143991,694841,807803,1024387,442950,754103,1007242,227845,319010,567204,529493,795854,905931,554081,15346,1027891,1048885,70640,331021,946335,505003,149591,187118,158522,794307,869786,372591,506298,679253,912161,430289,246814,410301,731559,261054,1033294,517983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]