SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200683 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200683 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338503,673241,462384,493878,769057,130974,626992,1043664,597722,337602,400569,1044967,626780,718779,933351,537169,47235,936352,770823,532066,828517,819778,391217,901904,696684,200450,596352,428201,415515,166693,500983,809313,166463,391201,909944,278291,716131,394682,202360,71136,509758,51140,448938,862590,220002,743812,1019610,537760,366245,419985,454813,744822,307728,736872,268937,575075,15758,126023,356705,249635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]