SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681329 LIMIT 1 [ RunTime:0.001212s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681329 [ RunTime:0.005078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303408,796569,629651,370181,359930,951681,849018,567561,818405,616607,413425,269608,617907,429855,78422,611962,993686,604147,709433,236272,869420,954479,147560,289466,25667,835549,827771,776950,639327,961294,297770,606904,498811,170723,692434,658794,785562,149618,249319,214538,437767,10062,476484,132680,672378,236730,559256,143133,17313,382832,620059,714983,155538,714509,910391,986923,567904,790745,837487,971497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]