SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265411 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265411 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378203,704174,621158,297776,317456,925882,607243,896631,733672,927283,457358,831924,1025109,302246,186258,887671,915625,715288,508546,715742,863326,606606,568084,462653,344060,94612,377861,930080,144623,992894,446678,971861,549902,16376,372605,268420,807540,443551,264531,747762,411690,244761,889685,497407,1032492,892282,317029,7820,431413,598516,1003879,728734,98504,592537,912689,351709,1046615,342009,9284,421397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001919s ]