SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022818 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022818 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684754,776501,12194,780052,87198,132000,554296,58217,24050,608052,847773,135490,853831,726637,102860,1001851,476261,1014296,3010,523626,41208,658981,440648,112462,1006802,320602,468217,592406,58392,205957,1012679,636213,59953,234119,220537,248538,727031,559648,704636,752021,562685,184956,255619,326350,820103,264373,238996,783331,771366,638444,1036760,161944,617293,568091,654108,312885,39224,815673,827100,919517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]