SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303834 LIMIT 1 [ RunTime:0.000896s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303834 [ RunTime:0.002502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682202,33376,33942,739793,671615,509123,1046217,836573,912363,402839,1023333,354247,750902,118336,228720,238687,354314,1016403,254940,1039811,1033981,1048069,774144,389133,558102,477270,675900,16106,402281,22894,987129,686425,730693,403035,413894,429065,905658,870957,132283,983684,249765,336774,939786,1548,771830,632151,536505,435622,183417,435198,271181,742657,652836,395850,597187,279440,571893,146399,889226,999495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]