SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002727s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580070 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580070 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653687,153779,760530,892325,20674,665363,759247,137195,681526,549772,8586,860968,585060,1048664,678590,594057,716874,1046809,688960,231838,499160,514559,768531,860513,520729,126820,673641,555718,74211,211885,414264,1029041,474796,862192,746594,120768,978943,630501,325898,1031688,858880,372693,396137,480064,120367,479176,2341,559592,541169,949214,168437,919908,556586,125753,442077,1032636,155762,78844,603778,158282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]