SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004594s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406964 LIMIT 1 [ RunTime:0.003375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406964 [ RunTime:0.004281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428634,376759,581499,471932,279297,374286,900641,867610,832836,82885,265155,291016,1016734,507397,910346,524571,240024,509050,950897,53750,543865,185710,105238,332035,623472,43980,170932,362956,840142,975507,642917,815125,454354,224935,869311,785774,962007,584422,840381,273826,652846,776302,942335,786571,27500,707127,224243,958894,589205,905825,506674,771248,682562,20864,516283,391011,28376,180318,620373,532886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001856s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001344s ]