SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577914 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577914 [ RunTime:0.002637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457224,762691,690168,224467,25539,92406,531637,39572,53918,41333,712074,19321,505185,209317,547152,76614,432623,434654,1012685,596369,1047336,259505,274691,394398,437596,812232,458031,27526,513214,638569,253225,808434,174040,3029,361134,705403,531958,278186,1012708,326160,335755,766656,980398,629423,1039407,427069,406783,1030021,764971,300098,42367,335632,501630,76552,185858,554069,553651,211032,826802,1046887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]