SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409890 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409890 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798922,315108,64265,165930,1018894,486492,106884,379146,941813,416804,945151,222834,203142,39265,83462,873995,585280,769528,383386,65956,453317,755667,752139,22113,80858,688353,229459,35441,765411,441761,650965,479749,996565,877461,188072,481651,1019345,670060,435751,529534,916470,171466,243515,761120,120734,114884,696470,944131,155725,682953,131424,518304,1031149,175723,356060,299949,18071,521439,933208,909022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]