SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044803 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044803 [ RunTime:0.005128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590385,796195,300472,449260,390188,238410,911814,684720,280132,751989,662922,978143,138467,78299,826266,1033468,406448,222348,48208,167673,757603,555994,556432,802562,98288,647080,519171,414687,146457,1042716,497074,487034,528959,341721,979838,724904,658978,432659,229071,894552,587322,186382,798450,349282,278320,764038,949027,968795,686402,854009,44810,612890,172173,420186,107210,509320,904228,300800,714144,635290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001349s ]