SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430922 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430922 [ RunTime:0.002503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532914,134131,214162,50763,536587,290805,936581,925045,982595,114015,676274,147897,656180,144871,319704,763801,1026144,247317,352841,518541,397402,108080,250173,659682,748414,393953,154336,119450,123893,886607,587156,177575,50451,1024036,467963,142798,750012,1002357,251551,360260,342138,311973,514929,156915,157305,789741,1041333,85524,988617,405758,634821,372904,35476,713306,171327,1021068,125189,448257,515600,83954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]