SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512610 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512610 [ RunTime:0.003676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878768,537646,811144,309113,761573,223060,311720,599494,878086,960423,474843,703201,296221,807400,811685,718188,113170,573419,826277,349295,1030100,985881,236157,979488,91273,373169,381020,314303,624024,507846,354037,25403,904650,396421,639450,708421,244142,402823,58183,971144,748987,532268,283896,159946,617054,691439,666196,707693,195148,851455,752989,722545,1035855,183304,149387,703464,653687,964505,570378,157672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]