SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012393 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012393 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620751,482380,49381,1046693,941172,418859,1001071,823850,672557,378184,482179,253332,316574,757598,858824,605577,40822,520995,951864,193505,570422,322775,980010,146335,1000563,786312,454251,569009,4014,764868,528338,132031,1028878,287021,1043373,436944,811620,613752,468820,871779,250932,475043,452738,934885,312826,437770,343960,134949,538570,1015985,714156,230367,634800,758999,377241,606453,873698,691085,88649,243762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]