SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311109 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311109 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038537,588201,426055,333878,344616,736255,1047740,179892,483827,230464,818761,43869,811778,620492,234239,441249,35557,780279,101073,523496,701753,250387,317583,736001,1041813,1010790,418526,394910,967918,351028,440387,30251,773089,126303,967919,963354,565989,348837,835244,999689,900586,468663,802606,4150,96275,1031657,350549,162876,603314,898047,490499,503682,793422,293284,962029,623935,1030197,479759,521407,32342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]