SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526986 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526986 [ RunTime:0.002823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430595,511259,54608,964433,285793,211189,566718,890760,499225,633151,819932,361858,399998,150642,736462,707113,12631,157923,610939,159378,374794,938029,457429,53147,171537,885843,362478,210744,615459,489746,457392,55526,1022017,604653,336619,38993,844595,400028,481154,131279,663416,686854,287734,119000,771088,30200,896941,1016299,290444,819394,159371,763032,260399,77145,523285,244041,67,976150,659015,435934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]