SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478680 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478680 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607019,825427,779024,44316,603091,144674,417784,199728,976571,1002642,256230,890888,561561,946512,782620,349142,729455,479201,617213,288441,562361,251325,168797,191136,666765,942904,415235,1037117,259174,615417,958022,299083,409163,338405,457981,508132,1037201,536634,1017267,952128,47025,1033566,36420,168745,696979,779584,8765,414933,256429,47940,7344,1023817,5385,123375,487343,711764,697581,777889,179485,274292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]