SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031694 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031694 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525738,443589,436293,998782,201721,163372,204117,439045,808295,593634,41873,925393,407233,307175,945332,283502,326449,115893,199866,255404,1036916,658160,347977,268822,77719,470588,484034,438666,863079,859687,121110,616747,935250,219411,704009,816098,74606,375042,616700,973696,453018,998833,282138,552166,233036,738801,714410,754959,9615,103292,608196,84264,402321,856274,627896,690681,909918,448219,178814,76649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]