SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039046 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039046 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187867,188574,16413,356181,359600,498200,180912,1015047,122285,265492,869651,1035974,204611,748851,208534,619720,635937,569560,934124,948600,979371,215342,260529,414962,422998,859636,195877,786692,793768,833621,910422,803011,744429,762063,799633,151738,231632,74682,981935,251214,843679,357556,711617,558882,163824,984014,470736,692780,693380,780925,679757,412781,876644,1007171,671286,35477,868940,998213,7373,820519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]