SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511771 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511771 [ RunTime:0.002845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005352,207855,339991,296932,1024635,785718,726883,115987,855471,404028,263584,344130,529264,442958,363570,286161,48660,269269,593882,94103,404358,43152,171238,181236,344712,743132,905400,1023214,552569,436731,770297,521414,177813,354942,755855,236020,538843,119979,532815,719734,105278,842968,665829,418127,307216,563234,532711,273403,954061,581576,837846,192514,320570,513088,17873,660558,29667,580254,619646,1008141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]