SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391404 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391404 [ RunTime:0.002858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004926,61388,1045699,954162,507991,687650,199107,869634,568213,585572,413562,879182,425148,247827,547002,201351,404239,73126,420517,900785,23940,178829,991654,836183,147499,976516,206590,498200,187132,1034091,682429,520900,319744,354277,968479,288642,169631,79153,502320,298160,484244,207484,800465,797904,872805,821915,321059,1001153,877888,1044995,251782,306078,795640,141026,838251,859528,671472,869156,386195,815961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]