SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519897 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519897 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937824,649186,74211,883156,597182,686098,877787,125388,703421,889381,64192,247446,832703,1001629,687463,120518,503143,34873,461665,628836,116559,750294,543930,1037126,487188,694253,395787,228139,786129,526481,114760,538310,306276,955636,787620,29807,936383,981947,1035674,715415,431084,1037132,610404,508346,233905,11445,18143,773940,158721,172199,351868,16833,64752,272517,347503,161897,397460,1032379,254482,35870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]