SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401531 LIMIT 1 [ RunTime:0.000592s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401531 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768691,296282,306230,519685,35966,617785,767533,438771,663358,841309,444808,497340,949137,1019100,914179,41222,278098,910969,713401,1042225,1000690,872717,285610,263095,377905,118146,908420,919845,128857,56885,448038,504531,1012430,930729,538984,511280,398006,998451,942645,525633,933047,937362,586166,9473,49210,893785,814122,344589,289200,448830,417483,586705,873200,393979,707554,195958,60545,428772,79275,731952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001859s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]