SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344513 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344513 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494782,700768,128180,748788,264692,431064,287758,153722,753162,890528,502288,102402,816538,4936,110482,16670,1042227,1017064,13833,956798,278132,117387,988853,235981,14983,322119,623428,485538,828816,325663,213618,771282,997601,740196,654926,143260,124348,225146,837767,792048,1039743,409096,940439,818643,804757,714302,746219,503345,815292,802546,253123,68579,465687,196205,541824,345838,799206,62207,267651,772064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]