SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001663s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012037 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012037 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109264,393496,505287,585617,774720,955143,311904,931489,825364,860098,504199,789186,694364,615953,145656,180678,30728,512124,858514,214622,971062,309704,1045415,111770,155688,503347,453425,826263,339956,836680,772628,442476,263555,344632,557133,155716,427993,296159,284929,456396,336353,777600,1020969,445827,442034,507220,41576,587341,995879,131959,722292,644898,126248,73770,879997,737619,548687,706082,639674,515102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003173s ]