SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510834 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510834 [ RunTime:0.001417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703273,993705,487392,246924,617473,503999,21227,519850,934760,925240,507388,318693,439917,365288,133433,874106,302837,438199,215938,459415,1011332,789035,378181,425217,979967,521821,522700,843016,639448,294756,931371,520281,837882,970857,23059,625890,743984,52232,779236,240388,336379,759077,558030,612315,405077,92868,116322,1038416,599029,841516,915360,158845,929954,359636,877651,825194,943677,142412,897873,160981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]