SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022600 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022600 [ RunTime:0.002016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835278,902526,923510,973615,109842,698518,436989,698050,920023,236443,837099,140312,985228,531940,617403,61363,267358,950401,809117,210102,434760,495592,399446,417855,587614,436973,682563,44070,883017,745259,361410,243692,594117,503353,613632,28189,444864,1001022,101098,786377,288277,35940,215782,847859,980261,500054,141949,934691,755917,307842,324565,686311,78700,57646,546776,908833,448554,679921,661547,35006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]