SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407254 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407254 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178872,151168,784024,758191,872780,135317,104518,489180,862211,599495,939604,1007196,313579,314579,109204,331829,562040,916542,1266,861608,834378,12320,636455,140237,738441,206892,306832,636746,93935,214110,1032,642539,622939,141153,594357,447580,688253,244623,715256,959944,543528,353617,521953,923077,651018,909971,448661,589957,645923,667723,358298,783199,213748,284818,839720,266183,342975,401835,714265,961149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]