SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002241 LIMIT 1 [ RunTime:0.003398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002241 [ RunTime:0.004738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855071,59237,637518,678308,1012142,410595,395495,622426,583380,1047888,125908,326479,682482,762403,770759,169716,67484,506261,353603,301912,508069,983501,923532,948258,887928,348352,588675,451138,114629,59776,229960,837788,267022,98684,1037760,379355,888242,1018745,504543,570031,751173,997694,505343,862272,627457,150411,592287,694274,1015540,814779,118822,975186,766610,438588,632894,960669,595705,181373,704752,357406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]