SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001986s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414505 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414505 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642093,894314,820976,305930,681439,19597,304327,831956,133019,285916,531776,73877,900542,756221,234177,891253,715893,302956,120795,508138,1006184,288786,53560,490810,50417,937109,63391,1009008,422860,759767,532905,280723,934036,644629,579890,159472,369353,12818,296102,719875,928269,719842,671818,998336,27188,992486,825292,913261,617927,302622,921087,35900,326328,900305,113293,161864,306245,635686,425844,1029107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]