SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501240 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501240 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359951,650877,337572,165662,869420,820412,588646,97591,654882,802294,1038039,350287,728180,587153,547787,1005135,853190,596239,887258,757751,75532,987648,76295,7996,800249,29863,473650,142618,1017364,535361,973385,1020735,1005972,848678,253690,6171,343936,128793,83453,168519,139036,351373,921094,690663,189030,550802,862877,369830,953578,721913,387148,468758,362661,714088,967953,29776,415542,290178,368310,372587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002760s ]