SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012907 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012907 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (870168,751140,5505,978407,596829,778850,35905,418574,123420,221961,489726,576518,497947,518612,776231,804814,937559,961658,294849,1034500,789227,222627,165160,250617,1029439,729956,630988,582414,191204,955866,948248,1007918,879387,278941,251436,996427,639591,629471,87914,1031785,715447,614550,948813,483301,593234,122405,90223,935272,756377,204676,965591,521377,377567,711231,17090,894740,241291,602099,242138,887540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001548s ]