SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025040 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025040 [ RunTime:0.003947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433794,873229,274514,233695,673831,34638,93525,539573,348521,569154,434510,1009315,783087,862735,394066,563872,4602,319552,175176,221303,848862,1029849,720275,35733,651419,253076,556718,413189,112952,436132,762777,781855,78449,641632,97136,430204,795437,205182,192872,946336,307992,627346,931005,413682,337026,838025,183659,722487,760379,979056,651147,1024840,787609,1037496,814061,962736,178238,834979,797885,714114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]