SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390514 LIMIT 1 [ RunTime:0.003059s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390514 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544022,923619,360112,179704,3060,930148,352955,585338,432053,993860,916285,376510,869142,58504,473682,538064,646717,414235,1025981,830008,177126,991441,810514,299434,809305,746319,44567,957706,614288,843469,753050,239495,1002349,512900,34243,550185,391953,911066,57493,905550,88660,608859,976683,651596,641040,251193,412804,815345,198149,915490,576368,133500,180621,639238,281042,554346,929192,85756,1040217,293092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]