SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 259194 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 259194 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001969,698323,712160,166273,585491,465623,718168,714983,500568,635353,231380,614158,171927,104428,353254,253148,864839,621114,445557,85775,1013639,283946,830490,68403,164807,712555,166118,788941,970509,836634,339168,1020808,413798,1043974,229653,784320,917443,74325,236617,1003591,753369,255607,641644,130171,882589,907892,139202,205964,511874,682191,76597,1034224,703696,195250,376840,234181,970506,847450,245524,198398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 259194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 259194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000887s ]