SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472508 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472508 [ RunTime:0.003311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815112,744235,190122,885120,645698,242342,358571,652313,996958,906086,661258,717475,289164,675808,662381,743358,23502,440355,863611,128721,451020,329428,270122,71436,327487,26328,974864,534932,961516,283039,726350,308350,233202,332904,610904,389822,932136,919214,910403,561973,555134,526698,145375,725333,799134,303032,1041292,396091,8706,137079,52023,536830,548307,721769,286202,368431,652977,462221,1028591,790534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000760s ]