SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316014 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316014 [ RunTime:0.002356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834927,306184,224170,41649,1012284,1000407,566089,817526,469976,572727,939738,204182,1045384,1034572,130871,810868,582206,917575,274578,215903,146917,141389,359580,897893,1001279,804926,998935,5275,518780,1035733,442092,101748,70388,190077,1011489,772426,702176,927385,992452,58855,990818,747230,896183,133911,565424,666570,84092,435461,722434,292538,935389,374653,686109,337091,291230,474696,612877,958230,327927,116020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]