SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002008s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514142 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514142 [ RunTime:0.002086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544861,366128,472106,86365,807732,971546,259667,347510,549751,303788,972501,851693,204678,527873,939016,708113,486939,438638,955715,225654,376571,710266,227949,224457,117219,616310,102487,901525,966656,308899,1009100,952702,476744,784554,179392,898623,257401,886267,652686,367497,41664,398992,670489,285952,601425,689693,148034,258774,801474,100232,1041223,74652,912248,547491,580106,468183,241328,892326,488049,452872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]