SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 694891 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 694891 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49108,788375,178242,840712,383487,161986,1045357,118770,275884,577670,1036852,1045931,628091,1566,807907,968968,920460,576590,163311,887106,152678,200929,380867,860502,113298,332355,991229,180627,547599,762140,802836,1020284,140425,270042,877831,220545,534784,410589,52961,127259,1038439,690624,30850,697520,411705,676634,812176,211600,366146,933924,823388,172244,617745,790457,773194,391534,523835,451681,231749,462752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 694891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 694891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002456s ]